Adding validations
We have validated many of the grouping columns in your RFGroup and RFCode dimensions tables for you. To ensure that you have the correct codes in your dimensions, use the following steps to ensure your dimensions are configured properly.
The following table lists the lookup columns and the corresponding default values for the specified dimensions:
| Dimension | Lookup Column | Default Value |
|---|---|---|
| ACCT.RFCODE | RFCODE.RFCODE | 'Z_Exclude' |
| DEPT.RFGROUP | RFGROUP.RFGROUP | ‘NA’ |
| RFCODE.Statement | ACCT_Statement.Statement | ‘NA’ |
| RFCODE.Type | ACCT_Type.Type | ‘NA’ |
| RFCODE.FSSummary | ACCT_FSSUMMARY.FSSUMMARY | ‘NA’ |
| RFCODE.FSDETAIL | ACCT_FSDETAIL.FSDETAIL | ‘NA’ |
| RFCODE.RFSum | RFCODE_RFSUM.RFSUM | ‘NA’ |
| RFCODE.RFStdLine | RFCODE_RFSTDLINE.RFSTDLINE | 'NA' |
| RFCODE.KHABgtCode | RFCODE.RFCODE | 'Z_Exclude' |
| RFCODE.RFINITSTDLINE | RFCODE_RFINITSTDLINE.RFCODE_RFINITSTDLINE | 'NA' |
| RFGROUP.Entity | ENTITY.ENTITY | 0 |
| RFGROUP.RPTMap | RFGROUP.RFGROUP | 'NA' |
| RFGROUP.KHABgtTemplate | DEPT_KHABGTTemplate.KHABgtTemplate | 'NA' |
| RFGROUP.TPLOptions | DEPT_TPLOPTIONS.TPLOptions | 'NA' |
| RFGROUP.KHABgtCode | RFGROUP.RFGROUP | 'NA' |
| RFGROUP.KHABgtMap | RFGROUP.RFGROUP | 'NA' |
To validate dimensions:
-
In the Explorer task pane, in the Libraries section, click Table Library > !Dimensions.
-
Right-click the dimension table, and click Edit table structure.
- In the Edit Table dialog, click the Columns tab.
-
In the Lookup Column field, select the lookup column to select the default for.
- In the Default Value field, type the default value for the column.
- Click OK.
- After you are done making your changes, in the Main ribbon tab, click Save.
